

select euserid as buid,count(distinct resumeId) as resumedownload_cnt
from hdp_lbg_supin_clickhousedb.hdp_lbg_supin_dwd_zp_resume_download
where toYYYYMMDDhhmmss(e_time) >= '%s'  and toYYYYMMDDhhmmss(e_time) <  '%s'
group by euserid